package com.qf.mapper;

import com.qf.model.Item;
import com.qf.model.Subitem;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface ItemMapper {

    //当前页结果
    public List<Item> findPage(@Param("currentPage")Integer currentPage, @Param("pageSize")Integer pageSize, @Param("queryString")String queryString);

    //总记录数
    public Long count(String queryString);
    //增加开发商
    public int addOne(Item item);


    //根据iid查询item
    public Item findById( String iid);

    //修改item
    int editOne(Item item);

    //删除item
    int delete(String iid);

    @Select("select * from item where suid=#{suid} and status=1 ")
    List<Item> findBySuid(String suid);
}
